/*
 Navicat Premium Data Transfer

 Source Server         : dn07
 Source Server Type    : MySQL
 Source Server Version : 80011
 Source Host           : dn07:3306
 Source Schema         : dldsj

 Target Server Type    : MySQL
 Target Server Version : 80011
 File Encoding         : 65001

 Date: 10/05/2019 17:03:58
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tb_paralleltool
-- ----------------------------
DROP TABLE IF EXISTS `tb_paralleltool`;
CREATE TABLE `tb_paralleltool` (
  `ARTIFACT_ID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `NAME` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '',
  `DESCRIPTION` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `ALGO` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `USAGES` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '',
  `MAIN_CLASS` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '',
  `FRAMEWORK_TYPE` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '',
  `DATE` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '',
  `VERSION_ID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '',
  `KEYWORDS` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '',
  `GROUP_ID` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '',
  `AUTHOR_ID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '',
  `EMAIL` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '',
  `INPUT` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `OUTPUT` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `PARAMETERS` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `PACKAGES` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `INTERFACES` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `TEST` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `JAR_PATH` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '',
  `XML_PATH` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '',
  `NUM_EXECUTORS` int(11) DEFAULT '4',
  `DRIVER_MEMORY` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '4g',
  `EXECUTOR_MEMORY` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '4g',
  `EXECUTOR_CORES` int(11) DEFAULT '1',
  `PARALLELISM` int(11) DEFAULT '64',
  `HAVE_INDEX` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'UNDEFINED',
  `PIC_PATH` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '',
  PRIMARY KEY (`ARTIFACT_ID`) USING BTREE,
  KEY `ARTIFACT_ID` (`ARTIFACT_ID`) USING BTREE,
  KEY `ARTIFACT_ID_2` (`ARTIFACT_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of tb_paralleltool
-- ----------------------------
BEGIN;
INSERT INTO `tb_paralleltool` VALUES ('addrMatch', '地址匹配服务接口', '', '', 'trjanls', 'com.igsnrr.datamining.algorithm.njnu.addrMatch.SparkTest', 'spark', '20190410', '1.0', '', '南京师范大学', '赵文强', '', '[{\"path\":\"hdfs\",\"type\":\"txt\",\"fields\":[{\"default\":\"\",\"datatype\":\"Double\",\"name\":\"lon\",\"description\":\"经度\",\"required\":\"true\"},{\"default\":\"\",\"datatype\":\"Double\",\"name\":\"lat\",\"description\":\"纬度\",\"required\":\"true\"}]},{\"path\":\"hdfs\",\"type\":\"txt\",\"fields\":[{\"default\":\"\",\"datatype\":\"Double\",\"name\":\"lon\",\"description\":\"经度\",\"required\":\"true\"},{\"default\":\"\",\"datatype\":\"Double\",\"name\":\"lat\",\"description\":\"纬度\",\"required\":\"true\"}]}]', '[{\"path\":\"file\",\"type\":\"txt\",\"fields\":[{\"default\":\"\",\"datatype\":\"String\",\"name\":\"ClusterID\",\"description\":\"点所属类别\",\"required\":\"true\"},{\"default\":\"\",\"datatype\":\"Array[Double]\",\"name\":\"Point\",\"description\":\"点对象值\",\"required\":\"true\"},{\"default\":\"\",\"datatype\":\"Double\",\"name\":\"nnDist\",\"description\":\"点到聚类中心的距离\",\"required\":\"true\"}]},{\"path\":\"file\",\"type\":\"txt\",\"fields\":[{\"default\":\"\",\"datatype\":\"String\",\"name\":\"ClusterID\",\"description\":\"点所属类别\",\"required\":\"true\"},{\"default\":\"\",\"datatype\":\"Array[Double]\",\"name\":\"CenterX\",\"description\":\"聚类中心\",\"required\":\"true\"}]}]', '[{\"default\":\"\",\"datatype\":\"String\",\"in\":\"0\",\"name\":\"输入文件路径\",\"description\":\"存放原地名数据的文本文件路径\",\"source\":\"fs\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"输出文件路径\",\"description\":\"存放地名匹配结果文件\",\"out\":\"0\"}]', '[{\"name\":\"GeoSpark\",\"version\":\"1.1.3\",\"url\":\"https://github.com/DataSystemsLab/GeoSpark\"}]', '[]', '{\"cmdline\":\"spark2-submit\\n\\t\\t--master yarn-cluster \\n\\t\\t--num-executors 4 \\n\\t\\t--executor-memory 2G \\n\\t\\t--executor-cores 4 \\n\\t\\tmobile.DataCleaning \\n\\t\\tpopfluxmodel-0.0.2.jar /testdata/shp_prj/grid /testdata/sim.txt /output/usercleaned 100\"}', '/opt/dldsj/upload/jar/addrMatch.jar', '/opt/dldsj/upload/template/addrMatch.xml', 4, '4g', '4g', 1, 64, 'UNDEFINED', 'static/addrMatch.png');
INSERT INTO `tb_paralleltool` VALUES ('AnomalyDetection', '异常检测', '模型读取格网尺度腾讯定位请求时间序列，进行异常检测', '', 'example', '', 'spark', '20100428', '1.0', '异常检测', '中国科学院地理科学与资源研究所', '易嘉伟', 'yijw@lreis.ac.cn', '[{\"path\":\"hdfs\",\"type\":\"txt\",\"fields\":[{\"datatype\":\"String\",\"name\":\"uid\",\"description\":\"序列号\"},{\"datatype\":\"Double\",\"name\":\"lon\",\"description\":\"经度\"},{\"datatype\":\"Double\",\"name\":\"lat\",\"description\":\"纬度\"},{\"datatype\":\"Double\",\"name\":\"[timestamp]\",\"description\":\"网格在[timestamp]时段的定位请求量\"}]}]', '[{\"path\":\"file\",\"type\":\"txt\",\"fields\":[{\"datatype\":\"String\",\"name\":\"uid\",\"description\":\"序列号\"},{\"datatype\":\"String\",\"name\":\"timestamp\",\"description\":\"时间戳（YYYY/MM/DD HH:mm）\"},{\"datatype\":\"Double\",\"name\":\"lon\",\"description\":\"经度\"},{\"datatype\":\"Double\",\"name\":\"lat\",\"description\":\"纬度\"},{\"datatype\":\"Double\",\"name\":\"anoms\",\"description\":\"异常网格的定位请求量\"}]}]', '[{\"default\":\"\",\"datatype\":\"String\",\"in\":\"0\",\"name\":\"定位请求数据文件\",\"description\":\"定位请求数据文件路径（csv）\",\"source\":\"platform\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"输出路径\",\"description\":\"存放计算后的结果文件,各字段以制表符隔开\",\"out\":\"0\"}]', '[{\"name\":\"AnomalyDetection\",\"version\":\"0.0.2\",\"url\":\"https://github.com/Marcnuth/AnomalyDetection\"}]', '[]', '{\"cmdline\":\"./bin/spark-submit \\n\\t\\t--master yarn \\n\\t\\t--deploy-mode cluster \\n\\t\\t--num-executors 4 \\n\\t\\t--executor-memory 2G \\n\\t\\t--executor-cores 4 \\n\\t\\t--conf spark.default.parallelism=32 \\n\\t\\t--py-files lib.zip \\n\\t\\tspatial_filter.py /houseinfo 110,25,115,30 /houseinfo_filter\"}', '/opt/dldsj/upload/jar/AnomalyDetection.py,/opt/dldsj/upload/jar/AnomalyDetection.zip', '/opt/dldsj/upload/template/AnomalyDetection.xml', 4, '4g', '4g', 1, 4, 'UNDEFINED', 'static/AnomalyDetection.png');
INSERT INTO `tb_paralleltool` VALUES ('anomScore', '异常分值评算', '对异常的时间格网进行异常打分', '', 'example', '', 'spark', '20100428', '1.0', '异常检测', '中国科学院地理科学与资源研究所', '易嘉伟', 'yijw@lreis.ac.cn', '[{\"path\":\"hdfs\",\"type\":\"txt\",\"fields\":[{\"datatype\":\"String\",\"name\":\"uid\",\"description\":\"序列号\"},{\"datatype\":\"String\",\"name\":\"timestamp\",\"description\":\"时间戳（YYYY/MM/DD HH:mm）\"},{\"datatype\":\"Double\",\"name\":\"lon\",\"description\":\"经度\"},{\"datatype\":\"Double\",\"name\":\"lat\",\"description\":\"纬度\"},{\"datatype\":\"Double\",\"name\":\"anoms\",\"description\":\"异常网格的定位请求量\"}]}]', '[{\"path\":\"file\",\"type\":\"txt\",\"fields\":[{\"datatype\":\"String\",\"name\":\"uid\",\"description\":\"序列号\"},{\"datatype\":\"String\",\"name\":\"timestamp\",\"description\":\"时间戳（YYYY/MM/DD HH:mm）\"},{\"datatype\":\"Double\",\"name\":\"score\",\"description\":\"异常分值\"},{\"datatype\":\"Double\",\"name\":\"indicator\",\"description\":\"探测器\"}]}]', '[{\"default\":\"\",\"datatype\":\"String\",\"in\":\"0\",\"name\":\"定位请求数据文件\",\"description\":\"定位请求数据文件路径（csv）\",\"source\":\"platform\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"输出路径\",\"description\":\"存放计算后的结果文件,各字段以制表符隔开\",\"out\":\"0\"}]', '[]', '[]', '{\"cmdline\":\"./bin/spark-submit \\n\\t\\t--master yarn \\n\\t\\t--deploy-mode cluster \\n\\t\\t--num-executors 4 \\n\\t\\t--executor-memory 2G \\n\\t\\t--executor-cores 4 \\n\\t\\t--conf spark.default.parallelism=32 \\n\\t\\t--py-files lib.zip \\n\\t\\tspatial_filter.py /houseinfo 110,25,115,30 /houseinfo_filter\"}', '/opt/dldsj/upload/jar/anomScore.py', '/opt/dldsj/upload/template/anomScore.xml', 4, '4g', '4g', 1, 64, 'UNDEFINED', 'static/anomScore.png');
INSERT INTO `tb_paralleltool` VALUES ('BasicStat', '基本统计', '系统内置的数据按字段统计模型，用于对公共数据的基本统计（包括求和、计数、均值、最值、方差）', '', '', 'edu.zju.gis.dldsj.stat.BasicStat', 'spark', '20180808', '1.0', '条件过滤;基本统计', '浙江大学', '李延龙', 'liyanlong@zju.edu.cn', '[{\"path\":\"platform\",\"type\":\"platform\",\"fields\":[]}]', '[{\"type\":\"txt\",\"fields\":[]}]', '[{\"datatype\":\"String\",\"in\":\"0\",\"name\":\"数据名称\",\"description\":\"系统公共数据的名称\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"最终结果包含的字段\",\"description\":\"默认为`*`\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"时间范围\",\"description\":\"用逗号或连字符连接的两个毫秒数\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"经纬度四至范围\",\"description\":\"用逗号分隔的minx,miny,maxx,maxy\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"空间范围WKT\",\"description\":\"标准WKT文本，支持复杂类型的GeometryCollection\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"SQL条件语句\",\"description\":\"参考SparkSQL对SQL的支持\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"分组字段\",\"description\":\"用于数据的分组\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"统计字段\",\"description\":\"分组数据的组内统计指标\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"结果输出路径\",\"description\":\"默认为HDFS路径，输出本地路径需添加file://前缀\",\"out\":\"0\"}]', NULL, NULL, '{\"cmdline\":\"spark-submit\\n            --master yarn\\n            --deploy-mode cluster\\n            --num-executors 4\\n            --executor-memory 4G\\n            --executor-cores 2\\n            --conf spark.default.parallelism=32\\n            --class edu.zju.gis.dldsj.stat.BasicStat\\n            --name 国民经济核算_1541076689675\\n            BasicStat.jar \\\"国民经济核算\\\" \\\"pk_id,city_name,year,gdp,consumption_per,regresidents_conlevel,reggeneral_pubbudget\\\"\\n            \\\"\\\" \\\"\\\" \\\"\\\" \\\"city=\\\\\\\"上海\\\\\\\" or city=\\\\\\\"北京\\\\\\\"\\\" \\\"city_name\\\" \\\"gdp\\\" \\\"file:///output/task/国民经济核算_1541076689675\\\"\"}', '/opt/dldsj/upload/jar/BasicStat.jar', '/opt/dldsj/upload/template/BasicStat.xml', 10, '2g', '4g', 2, 4, 'UNDEFINED', 'static/BasicStat.png');
INSERT INTO `tb_paralleltool` VALUES ('BKmeans', '基于二分Kmeans的层次聚类', '输入数据的格式为tsv或csv格式，输入文件根目录为点数据根目录，基于二分Kmeans算法计算各点数据属于的类别', '二分Kmeans算法属于自顶而下的层次聚类方法', 'spatialclustering', 'com.igsnrr.toolbox.spatialclustering.BKmeans', 'spark', '201807010', '1.0', '二分Kmeans;层次聚类', '中科院地理所', '王席', 'wangxi@lreis.ac.cn', '[{\"path\":\"hdfs\",\"type\":\"txt\",\"fields\":[{\"default\":\"\",\"datatype\":\"Double\",\"name\":\"lon\",\"description\":\"经度\",\"required\":\"true\"},{\"default\":\"\",\"datatype\":\"Double\",\"name\":\"lat\",\"description\":\"纬度\",\"required\":\"true\"}]},{\"path\":\"hdfs\",\"type\":\"txt\",\"fields\":[{\"default\":\"\",\"datatype\":\"Double\",\"name\":\"lon\",\"description\":\"经度\",\"required\":\"true\"},{\"default\":\"\",\"datatype\":\"Double\",\"name\":\"lat\",\"description\":\"纬度\",\"required\":\"true\"}]}]', '[{\"path\":\"file\",\"type\":\"txt\",\"fields\":[{\"default\":\"\",\"datatype\":\"String\",\"name\":\"ClusterID\",\"description\":\"点所属类别\",\"required\":\"true\"},{\"default\":\"\",\"datatype\":\"Array[Double]\",\"name\":\"Point\",\"description\":\"点对象值\",\"required\":\"true\"},{\"default\":\"\",\"datatype\":\"Double\",\"name\":\"nnDist\",\"description\":\"点到聚类中心的距离\",\"required\":\"true\"}]},{\"path\":\"file\",\"type\":\"txt\",\"fields\":[{\"default\":\"\",\"datatype\":\"String\",\"name\":\"ClusterID\",\"description\":\"点所属类别\",\"required\":\"true\"},{\"default\":\"\",\"datatype\":\"Array[Double]\",\"name\":\"CenterX\",\"description\":\"聚类中心\",\"required\":\"true\"}]}]', '[{\"default\":\"\",\"datatype\":\"String\",\"in\":\"0\",\"name\":\"空间点数据文件路径\",\"description\":\"存放原始空间点数据的文本文件路径\",\"source\":\"fs\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"空间点数据聚类结果文件路径\",\"description\":\"存放输出后的空间聚类结果文件\",\"out\":\"0\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"聚类中心文件路径\",\"description\":\"存放输出后的聚类中心结果文件\",\"out\":\"1\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"分割符类型\",\"description\":\"文本文件中各字段分割符 可选 csv|tsv\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"数据列序号\",\"description\":\"表示文件中每行数据的列序号 从0起算\"},{\"default\":\"\",\"datatype\":\"Integer\",\"name\":\"聚类类别个数\",\"description\":\"结果中聚类类别的个数\"},{\"default\":\"\",\"datatype\":\"Integer\",\"name\":\"最大迭代次数\",\"description\":\"计算聚类中心时迭代次数的最大值\"},{\"default\":\"\",\"datatype\":\"Integer\",\"name\":\"每个类中的最小个数\",\"description\":\"最终聚类结果中各个类中点的最小个数\"}]', '[]', '[{\"inParams\":[{\"default\":\"\",\"datatype\":\"\",\"name\":\"\",\"description\":\"\"}],\"outParams\":[{\"default\":\"\",\"datatype\":\"\",\"name\":\"\",\"description\":\"\"}]},{\"inParams\":[],\"outParams\":[]}]', '{\"outDesc\":\";\",\"cmdline\":\"./bin/spark-submit \\n\\t\\t--master yarn-cluster \\n\\t\\t--num-executors 4 \\n\\t\\t--executor-memory 2G \\n\\t\\t--executor-cores 4 \\n\\t\\t--conf spark.default.parallelism=32 \\n\\t\\t--class com.igsnrr.toolbox.spatialclustering.BKmeans \\n\\t\\ttoolbox-0.0.1.jar /testdata/20140801_ODpair_Filter /testdata/20140801_ODpair_Filter_Points /testdata/20140801_ODpair_Filter_Clusters csv 2,3 6 20 50\"}', '/opt/dldsj/upload/jar/BKmeans.jar', '/opt/dldsj/upload/template/BKmeans.xml', 4, '4g', '4g', 1, 4, 'UNDEFINED', 'static/BKmeans.png');
INSERT INTO `tb_paralleltool` VALUES ('CommunityDetection', '网络社区分割', '程序读入对应到网格的OD数据，然后利用Spark Graphx构建OD交互网络，最后通过LabelPropagation算法对网络进行社区划分，得到每个节点（网格）对应的社区类别', '1) LabelPropagation算法', 'networkanls', 'com.igsnrr.toolbox.MoBikeCommunity.CommunityDetection', 'spark', '20190429', '1.0', '网络构建;社区发现', '中科院地理所', '刘亚溪', 'liuyx@lreis.ac.cn', '[{\"path\":\"hdfs\",\"type\":\"csv\",\"fields\":[{\"default\":\"\",\"datatype\":\"String\",\"name\":\"order_id\",\"description\":\"订单的唯一标识符\",\"required\":\"true\"},{\"default\":\"\",\"datatype\":\"Long\",\"name\":\"StartGridID\",\"description\":\"起始点对应格网的ID\",\"required\":\"true\"},{\"default\":\"\",\"datatype\":\"Long\",\"name\":\"EndGridID\",\"description\":\"终止点对应格网的ID\",\"required\":\"true\"}]}]', '[{\"path\":\"file\",\"type\":\"txt\",\"fields\":[{\"default\":\"\",\"datatype\":\"String\",\"name\":\"grid_id\",\"description\":\"格网的唯一标识符\",\"required\":\"true\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"community_id\",\"description\":\"社区划分的类别\",\"required\":\"true\"}]}]', '[{\"default\":\"\",\"datatype\":\"String\",\"in\":\"0\",\"name\":\"对应到网格的OD文件\",\"description\":\"存放ODGrid文件的路径\",\"source\":\"fs\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"社区划分结果文件\",\"description\":\"存放计算后的结果文件,各字段以逗号隔开\",\"out\":\"0\"},{\"default\":\"\",\"datatype\":\"Int\",\"name\":\"迭代次数\",\"description\":\"LabelPropagation算法迭代的次数\"}]', '[{\"name\":\"GeoSpark\",\"version\":\"1.1.3\",\"url\":\"https://github.com/DataSystemsLab/GeoSpark\"}]', '[]', '{\"cmdline\":\"spark2-submit  \\n\\t\\t--master yarn \\n\\t\\t--driver-memory 4G \\n\\t\\t--num-executors 9  \\n\\t\\t--executor-memory 4G \\n\\t\\t--executor-cores 12 \\n\\t\\t--conf \\\"spark.io.compression.codec=org.apache.spark.io.LZ4CompressionCodec\\\" \\n\\t\\t--conf \\\"spark.shuffle.manager=tungsten-sort\\\"  \\n\\t\\t--conf spark.default.parallelism=100 \\n\\t\\t--conf spark.speculation=true  \\n\\t\\t--conf spark.network.timeout=300 \\n\\t\\t--conf spark.kryoserializer.buffer.max=256m \\n\\t\\t--conf spark.kryoserializer.buffer=64m \\n\\t\\t--class com.igsnrr.toolbox.MoBikeCommunity.CommunityDetection MobikeCommunity.jar /user/liuyaxi/mobike/ODGrid /user/liuyaxi/mobike/Community 100\"}', '/opt/dldsj/upload/jar/CommunityDetection.jar', '/opt/dldsj/upload/template/CommunityDetection.xml', 4, '4g', '4g', 1, 64, 'UNDEFINED', 'static/CommunityDetection.png');
INSERT INTO `tb_paralleltool` VALUES ('Contiguous_Flow', '流的层次聚类_连续流对', 'Spark implementation of \"Mapping Large Spatial Flow Data with Hierarchical Clustering\"', 'details in Zhu X, Guo D. Mapping large spatial flow data with hierarchical clustering[J]. Transactions in GIS, 2014, 18(3): 421-435.\n	 this procedure implements step1,2,3', 'spatialclustering', 'com.igsnrr.toolbox.flow.Hierarch.CongFlow', 'spark', '20190509', '1.0', '流聚类;k邻域', '中科院地理所', '王席', 'wangxi@lreis.ac.cn', '[{\"path\":\"hdfs\",\"type\":\"txt\",\"fields\":[{\"datatype\":\"String\",\"name\":\"flow_id\",\"description\":\"流编号\"},{\"datatype\":\"String\",\"name\":\"o_time\",\"description\":\"O点时间\"},{\"datatype\":\"Double\",\"name\":\"o_x\",\"description\":\"O点x坐标\"},{\"datatype\":\"Double\",\"name\":\"o_y\",\"description\":\"O点y坐标\"},{\"datatype\":\"String\",\"name\":\"d_time\",\"description\":\"D点时间\"},{\"datatype\":\"Double\",\"name\":\"d_x\",\"description\":\"D点x坐标\"},{\"datatype\":\"Double\",\"name\":\"d_y\",\"description\":\"D点y坐标\"}]}]', '[{\"path\":\"file\",\"type\":\"txt\",\"fields\":[{\"default\":\"\",\"datatype\":\"String\",\"name\":\"flowp\",\"description\":\"flowp\",\"required\":\"true\"},{\"default\":\"\",\"datatype\":\"Long\",\"name\":\"flowq\",\"description\":\"flowq\",\"required\":\"true\"},{\"default\":\"\",\"datatype\":\"Double\",\"name\":\"distpq\",\"description\":\"distpq\",\"required\":\"true\"}]}]', '[{\"default\":\"\",\"datatype\":\"String\",\"in\":\"0\",\"name\":\"流文件\",\"description\":\"流文件\",\"source\":\"fs\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"K\",\"description\":\"流的K阶邻域\",\"source\":\"fs\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"连续流对文件路径\",\"description\":\"连续流对文件路径\",\"out\":\"0\"}]', '[{\"name\":\"GeoSpark\",\"version\":\"1.1.3\",\"url\":\"https://github.com/DataSystemsLab/GeoSpark\"}]', '[]', '{\"cmdline\":\"spark2-submit\\n\\t\\t--master yarn-cluster \\n\\t\\t--num-executors 4 \\n\\t\\t--executor-memory 2G \\n\\t\\t--executor-cores 4 \\n\\t\\tpopest.DataCleaning \\n\\t\\tpopfluxmodel-0.0.2.jar /testdata/shp_prj/grid /testdata/sim.txt /output/usercleaned 100\"}', '/opt/dldsj/upload/jar/Contiguous_Flow.jar', '/opt/dldsj/upload/template/Contiguous_Flow.xml', 4, '4g', '4g', 1, 64, 'UNDEFINED', 'static/Contiguous_Flow.png');
INSERT INTO `tb_paralleltool` VALUES ('ConvexHullGenerator', '凸包生成接口', '凸包生成接口', '', 'example', '', 'spark', '20190508', '1.0', '凸包;空间;点', '北京大学', '龚旭日', 'gongxuri@pku.edu.cn', '[{\"path\":\"hdfs\",\"type\":\"txt\",\"fields\":[{\"datatype\":\"Double\",\"name\":\"lon\",\"description\":\"经度\"},{\"datatype\":\"Double\",\"name\":\"lat\",\"description\":\"维度\"},{\"datatype\":\"String\",\"name\":\"type id\",\"description\":\"点类别\"}]}]', '[{\"path\":\"hdfs\",\"type\":\"tsv\",\"fields\":[{\"datatype\":\"String\",\"name\":\"type id\",\"description\":\"类别id\"},{\"datatype\":\"String\",\"name\":\"polygon_wkt\",\"description\":\"凸包（wkt）\"}]}]', '[{\"default\":\"\",\"datatype\":\"String\",\"in\":\"0\",\"name\":\"输入文件路径\",\"description\":\"点数据文件\",\"source\":\"fs\"},{\"default\":\"4\",\"datatype\":\"Integer\",\"name\":\"经度列索引（从1开始）\",\"description\":\"经度列索引（从1开始）\"},{\"default\":\"3\",\"datatype\":\"Integer\",\"name\":\"纬度列索引（从1开始）\",\"description\":\"纬度列索引（从1开始）\"},{\"default\":\"-1\",\"datatype\":\"Integer\",\"name\":\"类别id列索引（从1开始）\",\"description\":\"类别id列索引（从1开始）\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"输出文件路径\",\"description\":\"输出文件路径\",\"out\":\"0\"}]', '[]', '[]', '{\"cmdline\":\"./bin/spark-submit\\n            --master yarn\\n            --deploy-mode cluster\\n            --num-executors 4\\n            --executor-memory 2G\\n            --executor-cores 4\\n            --conf spark.default.parallelism=32\\n            --py-files MHD.py input1 input2 output\"}', '/opt/dldsj/upload/jar/ConvexHullGenerator.py', '/opt/dldsj/upload/template/ConvexHullGenerator.xml', 4, '4g', '4g', 1, 64, 'UNDEFINED', 'static/ConvexHullGenerator.png');
INSERT INTO `tb_paralleltool` VALUES ('CrowdFluxEstimation', '人口通量估计', '序读入重建后的用户格网轨迹序列，在给定时间，格网尺度，速度阈值的情况下，计算某一时段(给定时刻的前后半小时内)且速度在该阈值下的各个格网的人口通量(单位为：trips/(km2*h))', '每个格网的分别可以计算得到流入通量和流出通量：当一个用户在一个时间段内不在一个网格，而下一个时间段却进入这个网格时，该网格的流入通量增加1；与之相对应的是，当一个用户在前一个时间段内处于一个网格，然后在随后的一个时间段内离开该网格时，该网格的流出通量增加1。', 'trjanls', 'mobile.CrowdFluxEstimation', 'spark', '20190410', '1.0', '人口通量;线性插值', '中科院地理所', '王席', 'wangxi@lreis.ac.cn', '[{\"path\":\"hdfs\",\"type\":\"txt\",\"fields\":[{\"default\":\"\",\"datatype\":\"String\",\"name\":\"uid\",\"description\":\"用户的唯一标识符\",\"required\":\"true\"},{\"default\":\"\",\"datatype\":\"Long\",\"name\":\"starttime\",\"description\":\"开始时间(时间戳,毫秒为单位)\",\"required\":\"true\"},{\"default\":\"\",\"datatype\":\"Long\",\"name\":\"endtime\",\"description\":\"结束时间(时间戳,毫秒为单位)\",\"required\":\"true\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"gridList\",\"description\":\"格网ID序列\",\"required\":\"true\"}]}]', '[{\"path\":\"file\",\"type\":\"txt\",\"fields\":[{\"default\":\"\",\"datatype\":\"Long\",\"name\":\"gridid\",\"description\":\"格网ID\",\"required\":\"true\"},{\"default\":\"\",\"datatype\":\"Double\",\"name\":\"influx\",\"description\":\"格网该时刻流入通量\",\"required\":\"true\"},{\"default\":\"\",\"datatype\":\"Double\",\"name\":\"outflux\",\"description\":\"格网该时刻流出通量\",\"required\":\"true\"}]}]', '[{\"default\":\"\",\"datatype\":\"String\",\"in\":\"0\",\"name\":\"重构后的用户格网ID序列文件\",\"description\":\"存放用户格网ID序列文件的路径\",\"source\":\"fs\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"人口通量文件路径\",\"description\":\"存放计算后的结果文件,各字段以逗号隔开\",\"out\":\"0\"},{\"default\":\"\",\"datatype\":\"Long\",\"name\":\"时刻\",\"description\":\"指定某一时刻的人口通量(yyyy-MM-dd HH:mm:ss)\"},{\"default\":\"\",\"datatype\":\"Double\",\"name\":\"速度阈值\",\"description\":\"保留速度小于该阈值的人群用于计算通量(单位:m/s)\"},{\"default\":\"\",\"datatype\":\"Double\",\"name\":\"格网分辨率\",\"description\":\"格网分辨率(单位为km)\"}]', '[{\"name\":\"GeoSpark\",\"version\":\"1.1.3\",\"url\":\"https://github.com/DataSystemsLab/GeoSpark\"}]', '[]', '{\"cmdline\":\"spark2-submit\\n\\t\\t--master yarn-cluster \\n\\t\\t--num-executors 4 \\n\\t\\t--executor-memory 2G \\n\\t\\t--executor-cores 4  \\n\\t\\tmobile.TrajectoryReconstruction \\n\\t\\tpopfluxmodel-0.0.2.jar /testdata/usergridseq /output/crowdflux 1554883200000 30.0 0.5\"}', '/opt/dldsj/upload/jar/CrowdFluxEstimation.jar', '/opt/dldsj/upload/template/CrowdFluxEstimation.xml', 4, '4g', '4g', 1, 64, 'UNDEFINED', 'static/CrowdFluxEstimation.png');
INSERT INTO `tb_paralleltool` VALUES ('dataClean', '数据清洗', '程序读入原始的定位请求数据文件zhuhai_test_grid.csv，根据设定的阈值筛选具有有效定位请求量的网格，剔除原始数据中几无定位请求数据的网格。', '', 'example', '', 'spark', '20100428', '1.0', '异常检测', '中国科学院地理科学与资源研究所', '易嘉伟', 'yijw@lreis.ac.cn', '[{\"path\":\"hdfs\",\"type\":\"txt\",\"fields\":[{\"datatype\":\"String\",\"name\":\"[ColIndex]_[RowIndex]\",\"description\":\"对应行列索引网格的定位请求量\"},{\"datatype\":\"String\",\"name\":\"timestamp\",\"description\":\"时间戳（YYYY/MM/DD HH:mm）\"}]}]', '[{\"path\":\"file\",\"type\":\"txt\",\"fields\":[{\"datatype\":\"String\",\"name\":\"uid\",\"description\":\"序列号\"},{\"datatype\":\"String\",\"name\":\"timestamp\",\"description\":\"网格在[timestamp]时段的定位请求量\"},{\"datatype\":\"Double\",\"name\":\"lon\",\"description\":\"经度\"},{\"datatype\":\"Double\",\"name\":\"lat\",\"description\":\"纬度\"}]}]', '[{\"default\":\"\",\"datatype\":\"String\",\"in\":\"0\",\"name\":\"定位请求数据文件\",\"description\":\"定位请求数据文件路径（csv）\",\"source\":\"platform\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"输出路径\",\"description\":\"存放计算后的结果文件,各字段以制表符隔开\",\"out\":\"0\"}]', '[{\"name\":\"AnomalyDetection\",\"version\":\"0.0.2\",\"url\":\"https://github.com/Marcnuth/AnomalyDetection\"}]', '[]', '{\"cmdline\":\"./bin/spark-submit \\n\\t\\t--master yarn \\n\\t\\t--deploy-mode cluster \\n\\t\\t--num-executors 4 \\n\\t\\t--executor-memory 2G \\n\\t\\t--executor-cores 4 \\n\\t\\t--conf spark.default.parallelism=32 \\n\\t\\t--py-files lib.zip \\n\\t\\tspatial_filter.py /houseinfo 110,25,115,30 /houseinfo_filter\"}', '/opt/dldsj/upload/jar/dataClean.py', '/opt/dldsj/upload/template/dataClean.xml', 4, '4g', '4g', 1, 4, 'UNDEFINED', 'static/dataClean.png');
INSERT INTO `tb_paralleltool` VALUES ('DataCleaning', '手机信令数据清洗', '程序读入原始用户点数据文件和格网几何对象grid.shp，根据设定的速度阈值对跳站情况进行处理（前后两点速度小于该阈值的进行保留），从而剔除原始数据中的异常点。并将用户点数据与格网进行空间叠加，将每个点映射到相应的格网中。', '1）对于单个用户的前后两点 若前后距离/时间差大于设定的速度阈值，则将后一个点进行舍弃\n	 2）用户点与空间格网的叠加', 'trjanls', 'mobile.DataCleaning', 'spark', '20190424', '1.0', '跳站处理;格网关联', '中科院地理所', '王席', 'wangxi@lreis.ac.cn', '[{\"path\":\"hdfs\",\"type\":\"txt\",\"fields\":[{\"default\":\"\",\"datatype\":\"String\",\"name\":\"uid\",\"description\":\"用户的唯一标识符\",\"required\":\"true\"},{\"default\":\"\",\"datatype\":\"Long\",\"name\":\"timestamp\",\"description\":\"采样点时间戳(毫秒)\",\"required\":\"true\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"lac\",\"description\":\"位置区编码\",\"required\":\"true\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"ci\",\"description\":\"扇区编码\",\"required\":\"true\"},{\"default\":\"\",\"datatype\":\"Double\",\"name\":\"lon\",\"description\":\"轨迹点经度\",\"required\":\"true\"},{\"default\":\"\",\"datatype\":\"Double\",\"name\":\"lat\",\"description\":\"轨迹点纬度\",\"required\":\"true\"}]},{\"path\":\"hdfs\",\"type\":\"shp\",\"fields\":[{\"default\":\"\",\"datatype\":\"Long\",\"name\":\"gid\",\"description\":\"格网的唯一标识符\",\"required\":\"true\"}]}]', '[{\"path\":\"file\",\"type\":\"txt\",\"fields\":[{\"default\":\"\",\"datatype\":\"String\",\"name\":\"uid\",\"description\":\"用户的唯一标识符\",\"required\":\"true\"},{\"default\":\"\",\"datatype\":\"Long\",\"name\":\"timestamp\",\"description\":\"采样点时间戳(毫秒)\",\"required\":\"true\"},{\"default\":\"\",\"datatype\":\"Double\",\"name\":\"lon\",\"description\":\"轨迹点经度\",\"required\":\"true\"},{\"default\":\"\",\"datatype\":\"Double\",\"name\":\"lat\",\"description\":\"轨迹点纬度\",\"required\":\"true\"},{\"default\":\"\",\"datatype\":\"Long\",\"name\":\"gridid\",\"description\":\"用户所属的格网ID\",\"required\":\"true\"}]}]', '[{\"default\":\"\",\"datatype\":\"String\",\"in\":\"0\",\"name\":\"格网shp文件\",\"description\":\"存放格网数据shp文件路径\",\"source\":\"fs\"},{\"default\":\"\",\"datatype\":\"String\",\"in\":\"1\",\"name\":\"用户点数据文本文件\",\"description\":\"存放原始信令数据的文本文件路径\",\"source\":\"fs\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"清洗后的用户点数据文件\",\"description\":\"存放计算后的结果文件路径\",\"out\":\"0\"},{\"default\":\"\",\"datatype\":\"Double\",\"name\":\"速度阈值\",\"description\":\"单位为m/s，速度小于该值的前后两点被保留\"}]', '[{\"name\":\"GeoSpark\",\"version\":\"1.1.3\",\"url\":\"https://github.com/DataSystemsLab/GeoSpark\"}]', '[]', '{\"cmdline\":\"spark2-submit\\n\\t\\t--master yarn-cluster \\n\\t\\t--num-executors 4 \\n\\t\\t--executor-memory 2G \\n\\t\\t--executor-cores 4 \\n\\t\\tmobile.DataCleaning \\n\\t\\tpopfluxmodel-0.0.2.jar /testdata/shp_prj/grid /testdata/sim.txt /output/usercleaned 100\"}', '/opt/dldsj/upload/jar/DataCleaning.jar', '/opt/dldsj/upload/template/DataCleaning.xml', 4, '4g', '4g', 1, 64, 'UNDEFINED', 'static/DataCleaning.png');
INSERT INTO `tb_paralleltool` VALUES ('DataQuery', '数据查询', '系统内置的数据查询模型，用于对公共数据的条件过滤查询', '', '', 'edu.zju.gis.dldsj.DataQuery', 'spark', '20180808', '1.0', 'SQL;空间过滤', '浙江大学', '李延龙', 'liyanlong@zju.edu.cn', '[{\"path\":\"platform\",\"type\":\"platform\",\"fields\":[]}]', '[{\"type\":\"txt\",\"fields\":[]}]', '[{\"datatype\":\"String\",\"in\":\"0\",\"name\":\"数据名称\",\"description\":\"系统共享数据名称\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"最终结果包含的字段\",\"description\":\"默认为`*`\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"时间范围\",\"description\":\"用逗号或连字符连接的两个毫秒数\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"经纬度四至范围\",\"description\":\"用逗号分隔的minx,miny,maxx,maxy\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"空间范围WKT\",\"description\":\"标准WKT文本，支持复杂类型的GeometryCollection\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"SQL条件语句\",\"description\":\"参考SparkSQL对SQL的支持\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"结果输出路径\",\"description\":\"默认为HDFS路径，输出本地路径需添加file://前缀\",\"out\":\"0\"}]', NULL, NULL, '{\"cmdline\":\"spark-submit\\n            --master yarn\\n            --deploy-mode cluster\\n            --num-executors 4\\n            --executor-memory 4G\\n            --executor-cores 2\\n            --conf spark.default.parallelism=32\\n            --class edu.zju.gis.dldsj.DataQuery\\n            --name 经济贸易情况_1541076586268\\n            DataQuery.jar \\\"经济贸易情况\\\" \\\"pk_id,city_name\\\" \\\"\\\" \\\"\\\" \\\"\\\" \\\"\\\" \\\"/output/task/经济贸易情况_1541076586268\\\"\"}', '/opt/dldsj/upload/jar/DataQuery.jar', '/opt/dldsj/upload/template/DataQuery.xml', 10, '2g', '4g', 2, 4, 'UNDEFINED', 'static/DataQuery.png');
INSERT INTO `tb_paralleltool` VALUES ('DBSCAN_Flow', 'DBSCAN流聚类', '模型读取流数据,使用DBSCAN方法进行聚类。流之间的距离定义为：两条流O点和D点距离加和', '', 'flow_clustering', 'com.igsnrr.toolbox.flow.DBSCAN.FindCores', 'spark', '20190427', '1.0', 'DBSCAN,流', '中科院地理所', '王席', 'wangxi@lreis.ac.cn', '[{\"path\":\"hdfs\",\"type\":\"txt\",\"fields\":[{\"datatype\":\"String\",\"name\":\"flow_id\",\"description\":\"流编号\"},{\"datatype\":\"String\",\"name\":\"o_time\",\"description\":\"O点时间\"},{\"datatype\":\"Double\",\"name\":\"o_x\",\"description\":\"O点x坐标\"},{\"datatype\":\"Double\",\"name\":\"o_y\",\"description\":\"O点y坐标\"},{\"datatype\":\"String\",\"name\":\"d_time\",\"description\":\"D点时间\"},{\"datatype\":\"Double\",\"name\":\"d_x\",\"description\":\"D点x坐标\"},{\"datatype\":\"Double\",\"name\":\"d_y\",\"description\":\"D点y坐标\"}]}]', '[{\"path\":\"file\",\"type\":\"txt\",\"fields\":[{\"datatype\":\"String\",\"name\":\"flow_id\",\"description\":\"流编号\"},{\"datatype\":\"Double\",\"name\":\"o_x\",\"description\":\"O点x坐标\"},{\"datatype\":\"Double\",\"name\":\"o_y\",\"description\":\"O点y坐标\"},{\"datatype\":\"Double\",\"name\":\"d_x\",\"description\":\"D点x坐标\"},{\"datatype\":\"Double\",\"name\":\"d_y\",\"description\":\"D点y坐标\"},{\"datatype\":\"String\",\"name\":\"clu_id\",\"description\":\"聚类编号\"}]},{\"path\":\"file\",\"type\":\"txt\",\"fields\":[{\"datatype\":\"String\",\"name\":\"clu_id\",\"description\":\"聚类编号\"},{\"datatype\":\"Int\",\"name\":\"size\",\"description\":\"类的大小\"},{\"datatype\":\"Double\",\"name\":\"o_x\",\"description\":\"O点x坐标\"},{\"datatype\":\"Double\",\"name\":\"o_y\",\"description\":\"O点y坐标\"},{\"datatype\":\"Double\",\"name\":\"d_x\",\"description\":\"D点x坐标\"},{\"datatype\":\"Double\",\"name\":\"d_y\",\"description\":\"D点y坐标\"}]}]', '[{\"default\":\"\",\"datatype\":\"String\",\"in\":\"0\",\"name\":\"流数据文件路径\",\"description\":\"流数据文件\",\"source\":\"fs\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"流聚类结果文件\",\"description\":\"流聚类结果文件，各字段以逗号隔开\",\"out\":\"0\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"流聚类中心结果文件\",\"description\":\"流聚类中心结果文件，各字段以逗号隔开\",\"out\":\"1\"},{\"default\":\"\",\"datatype\":\"Double\",\"name\":\"eps\",\"description\":\"eps邻域\"},{\"default\":\"\",\"datatype\":\"Integer\",\"name\":\"minpt\",\"description\":\"最小点数\"}]', '[]', '[]', '{\"cmdline\":\"./bin/spark-submit \\n\\t\\t--master yarn \\n\\t\\t--deploy-mode cluster \\n\\t\\t--num-executors 4 \\n\\t\\t--executor-memory 2G \\n\\t\\t--executor-cores 4 \\n\\t\\t--conf spark.default.parallelism=32 \\n\\t\\t--jars toolbox.jar \\n\\t\\tflow.FindCores /flowtest_xy.csv 2000 10 /flowtest_xy_cluster\"}', '/opt/dldsj/upload/jar/DBSCAN_Flow.jar', '/opt/dldsj/upload/template/DBSCAN_Flow.xml', 4, '4g', '4g', 1, 64, 'UNDEFINED', 'static/DBSCAN_Flow.jpg');
INSERT INTO `tb_paralleltool` VALUES ('DTW', '动态时间规整算法', '输入数据格式为TXT格式,输入文件根目录为文本数据根目录，基于给定的DTW算法求出最小结果。', '根据DTW算法，求出与各个记录DTW距离最小的记录及DTW距离值。', '计算DTW', 'com.igsnrr.datamining.algorithm.HBUE_SMG.DTW.DTW.DTWprocessing', 'spark', '20181015', '1.0', 'DTW', '中科院地理所', '承达愈', '', '[{\"path\":\"hdfs\",\"type\":\"txt\",\"fields\":[{\"default\":\"\",\"datatype\":\"String\",\"name\":\"trade\",\"description\":\"语义轨迹记录：String1 String2 String3...\",\"required\":\"true\"}]}]', '[{\"path\":\"file\",\"type\":\"txt\",\"fields\":[{\"default\":\"\",\"datatype\":\"String\",\"name\":\"X1\",\"description\":\"最近轨迹对及DTW距离值：Mac1\",\"required\":\"true\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"X2\",\"description\":\"最近轨迹对及DTW距离值：Mac2\",\"required\":\"true\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"X3\",\"description\":\"最近轨迹对及DTW距离值：Value\",\"required\":\"true\"}]}]', '[{\"default\":\"\",\"datatype\":\"Array[String]\",\"in\":\"0\",\"name\":\"轨迹记录集合\",\"description\":\"待求取相互间DTW距离的轨迹记录\"},{\"default\":\"default\",\"datatype\":\"String\",\"name\":\"输出数据路径\",\"description\":\"输出数据存储路径\",\"out\":\"0\"}]', NULL, '[{\"intfcClass\":\"com.igsnrr.datamining.algorithm.HBUE_SMG.DTW.DTW.DTWprocessing\",\"inParams\":[{\"default\":\"\",\"datatype\":\"String\",\"name\":\"trade\",\"description\":\"轨迹记录\"},{\"default\":\"\",\"datatype\":\"String\",\"name\":\"trade\",\"description\":\"轨迹记录\"}],\"name\":\"getDTWDistance\",\"outParams\":[{\"default\":\"\",\"datatype\":\"double\",\"name\":\"distance\",\"description\":\"两条轨迹记录间的DTW距离\"}],\"intfdesc\":\"计算DTW距离\"}]', '{\"outDesc\":\"各个Mac地址对应的最近Mac地址及编辑距离值\",\"cmdline\":\"./bin/spark-submit \\n\\t\\t--master yarn-cluster \\n\\t\\t--num-executors 4 \\n\\t\\t--executor-memory 2G \\n\\t\\t--executor-cores 4 \\n\\t\\t--conf spark.default.parallelism=32\\n\\t\\tcom.igsnrr.datamining.algorithm.HBUE_SMG.DTW.DTW.DTWprocessing\\n\\t\\t/dldsj/test/DTWtestdata.txt /dldsj/test/DTWResult/result.txt\",\"in\":\"/dldsj/test/DTWtestdata.txt\",\"inDesc\":\"N行不等长语义轨迹数据\",\"out\":\"/dldsj/test/DTWResult/result.txt\"}', '/opt/dldsj/upload/jar/DTW.jar', '/opt/dldsj/upload/template/DTW.xml', 4, '4g', '4g', 1, 4, 'UNDEFINED', 'static/DTW.png');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
